The Ultimate Guide to Functions in Power Query by Omid Motamedisedeh

Author:Omid Motamedisedeh
Language: eng
Format: epub
ISBN: 9781484297544
Publisher: Apress

In this case, the result is a record containing all fields (A, B, and C) as [A=5,B=2,C=10].

Record.Combine

To add more than one field to a record at the same time or to combine several records together, Record.Combine can be used as follows: Record.Combine(records as list) as record

To combine several records, all should be entered in a list as the first input of this function. In this case, the result is equal to a record that is obtained by combining all the records.

For example, to combine two records, the following formula can be used, which results in [A=5,B=2,C=10]: = Record.Combine({[A=5,B=2],[C=10]})

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.